CREATE EXTERNAL TABLE jms_tmp.tmp_yl_oms_order_mark_expand_hi
(
    waybill_id        string COMMENT '运单号',
    input_time        timestamp COMMENT '录入时间',
    id                bigint COMMENT '主键ID',
    order_id          bigint COMMENT '订单ID',
    field_name        string COMMENT '打标字段名称',
    field_value       string COMMENT '打标字段值',
    order_source_code string COMMENT '订单来源code',
    update_time       timestamp COMMENT '修改时间',
    is_delete         bigint COMMENT '是否删除 1：未删除 2：已删除'
)
    COMMENT '订单打标拓展临时表-导入sr'
    stored as parquet
    LOCATION '/dw/hive/jms_tmp.db/external/tmp_yl_oms_order_mark_expand_hi'
;